class CreateRequirements < ActiveRecord::Migration
  def self.up
    create_table :requirements do |t|
      t.string                :title
      t.integer               :reqid
      t.integer               :priority, :default => 0
      t.text                  :description
      t.string                :state
      t.date                  :start_time
      t.date                  :should_be_finish_time
      t.date                  :actually_finish_time
      t.date                  :actually_time_spent
      t.references            :project, :null => false
      t.references            :user, :null => false

      t.timestamps
    end
  end

  def self.down
    drop_table :requirements
  end
end
